FUNCTIONAL DATABASE

About

Objective:
My primary objective for this project was to design and implement a functional database system to facilitate efficient data management and retrieval.
The project encompasses the creation of a comprehensive database for storing essential details related to products, sales transactions, vendor information, and inventory management.

Outline:
-Database for storing product details, sales details, vendor details, and inventory details
-Populate and update database
-Backup database
-Stored procedures
-Create views

The tables were created in a particular other to enable the proper implementation of the Primary key and foreign key constraints.

Vendor Table:
• I initiated the database creation process by designing and implementing the Vendor table.
• Established the Vendor table with a single primary key constraint for precise vendor data management.
• Visual representation of Vendor table creation:.

Product Table:
• Designed and implemented the Product table, incorporating necessary constraints.
• Ensured data integrity by defining primary and foreign key relationships.
• Visual representation of Product table creation:

Sales Table:
• Created the Sales table to efficiently capture and manage sales records, including revenue tracking.
• Utilized primary and foreign key constraints to maintain data consistency.
• Visual representation of Sales table creation:

Inventory Table:
• Implemented the Inventory table, a pivotal component for monitoring product stock levels and determining restocking needs.
• The Inventory table plays a crucial role in inventory planning and management.
• Visual representation of Inventory table creation:

Data Population:
Populated the newly designed database with dummy data to ensure functionality and validate established relationships.
Employed Python, specifically the PYODBC and RANDOM libraries, to generate and insert mock data into the tables.

Python Integration:
Utilized Python scripting to automate data population across multiple tables within the database.
Python's PYODBC library facilitated seamless interaction with the database, enhancing efficiency and accuracy.

Conclusion:
This project provided me with invaluable experience in database management and SQL proficiency. The seamless integration of Python scripting into the data population process demonstrated the versatility and effectiveness of modern data management techniques..

You can check my GitHub repository for Full project documentation including code and implementation details.